package com.qfedu.hotelssm.controller;

import com.alibaba.excel.EasyExcel;
import com.qfedu.hotelssm.dto.CtStokeDto;
import com.qfedu.hotelssm.entity.CtStoke;
import com.qfedu.hotelssm.service.intf.CtStokeService;
import com.qfedu.hotelssm.vo.PageBean;
import com.qfedu.hotelssm.vo.R;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.multipart.MultipartFile;

import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.util.List;

/**
 * @author dzl
 * @date 2022/8/28 16:20
 */
@RestController
@RequestMapping("/api/stock/")
public class CtStokeController {
    @Autowired
    private CtStokeService service;

    //新增
    @PostMapping("save.do")
    public R save(CtStoke stoke){
        return service.save(stoke);
    }

    //删除
    @GetMapping("del.do")
    public R delete(int id){
        return service.del(id);
    }

    //查询
    @GetMapping("page.do")
    public PageBean page(String name,int page,int limit){
        return service.page(name, page, limit);
    }

    //修改
    @PostMapping("update.do")
    public R update(CtStoke stoke){
        return service.update(stoke);
    }

    //导出
    @GetMapping("download.do")
    public void download(HttpServletResponse response) throws IOException {
        //1.设置 响应消息头 下载
        response.setHeader("content-disposition","attachment;filename=stock-"+System.currentTimeMillis()+".xlsx");
        //2.查询菜单数据
        List<CtStokeDto> list=service.all();
        //3.实现数据写出 Excel生成
        EasyExcel.write(response.getOutputStream(), CtStokeDto.class).sheet().doWrite(list);
    }

    //导入-批量增加
    @PostMapping("upload.do")
    public R upload(MultipartFile file) throws IOException {
        return service.upload(file);
    }

    //批量删除
    @PostMapping("delids.do")
    public R delids(int[] ids){
        return service.delIds(ids);
    }

    //库存数量统计
    @GetMapping("stocktj.do")
    public R stockTj(){
        return service.stockTj();
    }
}
